Installing pl/pgsql under Irix 5.3

Dear all,

I'm having trouble installing PL/pgSQL under Irix 5.3.

at first gmake gave me the following error message:

merlin::postgres 52% gmake
cc -I../../../include -I../../../backend     -I../../../interfaces/libpq
-I../../../include -I../../../backend -c -o pl_parse.o pl_gram.c
cfe: Error: gram.y: 1460: Cannot open file pl_scan.c for #include
gmake: *** [pl_parse.o] Error 1

In desperation, I tried to comment out the #include line in gram.y and got:

merlin::postgres 52% gmake
/usr/bin/yacc -d gram.y
mv -f y.tab.c gram.c
sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <gram.c >pl_gram.c
sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <y.tab.h >pl.tab.h
cc -I../../../include -I../../../backend     -I../../../interfaces/libpq
-I../../../include -I../../../backend -c -o pl_parse.o pl_gram.c
cfe: Error: gram.y, line 1460: Syntax Error
 //#include "pl_scan.c"
 ^
cfe: Error: gram.y, line 1460: Unknown character # ignored
 //#include "pl_scan.c"
 --^
gmake: *** [pl_parse.o] Error 1

But because the install went slightly further, I decided to retry gmake (of
course removing the offending comment marks):

gmake
/usr/bin/yacc -d gram.y
mv -f y.tab.c gram.c
sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <gram.c >pl_gram.c
sed -e 's/yy/plpgsql_yy/g' -e 's/YY/PLPGSQL_YY/g' <y.tab.h >pl.tab.h
cc -I../../../include -I../../../backend     -I../../../interfaces/libpq
-I../../../include -I../../../backend -c -o pl_parse.o pl_gram.c
cc -I../../../include -I../../../backend     -I../../../interfaces/libpq
-I../../../include -I../../../backend   -c pl_handler.c -o pl_handler.o
cc -I../../../include -I../../../backend     -I../../../interfaces/libpq
-I../../../include -I../../../backend   -c pl_comp.c -o pl_comp.o
cc -I../../../include -I../../../backend     -I../../../interfaces/libpq
-I../../../include -I../../../backend   -c pl_exec.c -o pl_exec.o
cc -I../../../include -I../../../backend     -I../../../interfaces/libpq
-I../../../include -I../../../backend   -c pl_funcs.c -o pl_funcs.o
ar crs libplpgsql.a pl_parse.o pl_handler.o pl_comp.o pl_exec.o pl_funcs.o
/usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in
archive

/usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in
archive

/usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in
archive

/usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in
archive

Result I thought, until I tried gmake install:

merlin::root 1# gmake install
plpgsql not installed due to lack of shared library support.

What do I try next? (Irix 5.3, psSQL 6.4).

Regards,

Stuart.



+-------------------------+--------------------------------------+
| Stuart Rison            | Ludwig Institute for Cancer Research |
+-------------------------+ 91 Riding House Street               |
| Tel. (0171) 878 4041    | London, W1P 8BT, UNITED KINGDOM.     |
| Fax. (0171) 878 4040    | stuart@ludwig.ucl.ac.uk              |
+-------------------------+--------------------------------------+